 use SinhNhatDB
go

delete orderdetail
delete [order]
delete product
delete serviceorder
delete [service]
delete article
delete category
delete categoryservice
delete PAYMENT
delete account
delete parameter
go

insert into Account values
('{8A404ACC-0702-4940-BFAE-6F9D03901054}', 'Duong Than Dan', 'sa', '202cb962ac59075b964b07152d234b70', 0),
('{F31386F7-E717-46DF-ADB1-B32CD17441AE}', 'Ngoc Dai', 'dai', '202cb962ac59075b964b07152d234b70', 0)
go
insert into Parameter values
('{C6360368-1BFF-4D41-93AE-48816B0FB179}',N'From',N'trang.tri.to.chuc.tiec.web@gmail.com'),
('{1754B1C3-404E-4B8C-87C8-5DFE4642BC02}',N'Password',N'123456789hcm'),
('{D9D71946-0265-45BC-A5A5-E2DDB5FDA3AE}',N'To',N'duongthandan@gmail.com'),
('{322e31f3-525a-4de5-8843-22b9e15f5c0d}',N'youtube',N'greatpearl'),
('{8293a8c5-3257-4bb3-b813-defa6f311c7f}',N'facebook',N'greatpearl'),
('{13693272-4208-4fd0-a607-097383af342a}',N'yahoo',N'truonggimo'),
('{3219cf92-23b0-44b9-8755-8e9bc2d12cd8}',N'flickr',N'trangtritochhuctiec')

go
insert into Article values
('{BE0412FB-2128-4576-8D4A-7889B4887008}', '/trang-chu.aspx','{8A404ACC-0702-4940-BFAE-6F9D03901054}',N'Welcome', N'Tổ chức tiệc sinh nhật','2012-09-19 14:28:52.967',0)
go
insert into Category values
('F0193BB4-C385-4BC5-9EF8-606FF0D992A1','/trang-tri-tiec.aspx', N'Trang trí tiệc', null,1),
('16A9F7F3-8A15-4932-B5E4-74ACD7752FC6','/to-chuc-sinh-nhat.aspx', N'Dịch vụ tổ chức sinh nhật', null,2),
('B7E1E59D-1A78-4B35-A421-D1D7AE8D63E1', '/qua-sinh-nhat.aspx', N'Quà sinh nhật', null,3),
('54BD8C34-127B-44E4-B4BD-177346E4755F','/trang-tri-tiec-sinh-nhat.aspx',N'Trang trí tiệc sinh nhật','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',1),
('54BD8C34-127B-44E4-B4BD-177346E4756F','/trang-tri-tiec-cuoi-ki-niem.aspx',N'Trang trí tiệc cưới, kỉ niệm','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',2),
('54BD8C34-127B-44E4-B4BD-177346E4757F','/trang-tri-event-cong-ty.aspx',N'Trang trí event công ty','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',3),
('54BD8C34-127B-44E4-B4BD-177346E4758F','/nen-trang-tri-tiec.aspx',N'Nến trang trí tiệc','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',4),
('54BD8C34-127B-44E4-B4BD-177346E4759F','/trang-phuc-sinh-nhat-be.aspx',N'Trang phục sinh nhật bé','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',5),
(NEWID(),'/trang-tri-tiec-lang-man.aspx',N'Trang trí tiệc lãng mạn','F0193BB4-C385-4BC5-9EF8-606FF0D992A1',6),
(NEWID(),'/to-chuc-sinh-nhat-tron-goi.aspx',N'Tổ chức sinh nhật trọn gói','16A9F7F3-8A15-4932-B5E4-74ACD7752FC6',1),
(NEWID(),'/sinh-nhat-dau-doi-cua-be.aspx',N'Sinh Nhật Đầu Đời của bé','16A9F7F3-8A15-4932-B5E4-74ACD7752FC6',2),
(NEWID(),'/sinh-nhat-hong-cua-teen.aspx',N'Sinh Nhật Hồng của Teen nè!','16A9F7F3-8A15-4932-B5E4-74ACD7752FC6',3),
(NEWID(),'/party-ngoai-troi.aspx',N'Party ngoài trời','16A9F7F3-8A15-4932-B5E4-74ACD7752FC6',4)
go
insert into CategoryService values
('{17B7F6A6-48ED-4E4A-AA24-BFE4151B50B7}','/trang-tri-tiec2.aspx', N'Trang trí tiệc', null,1),
('{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}','/to-chuc-sinh-nhat2.aspx', N'Dịch vụ tổ chức sinh nhật', null,2),
('54BD8C34-127B-44E4-B4BD-177346E4755F','/trang-tri-tiec-sinh-nhat2.aspx',N'Trang trí tiệc sinh nhật','{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}',1),
('54BD8C34-127B-44E4-B4BD-177346E4756F','/trang-tri-tiec-cuoi-ki-niem2.aspx',N'Trang trí tiệc cưới, kỉ niệm','{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}',2),
('54BD8C34-127B-44E4-B4BD-177346E4757F','/trang-tri-event-cong-ty2.aspx',N'Trang trí event công ty','{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}',3),
('54BD8C34-127B-44E4-B4BD-177346E4758F','/nen-trang-tri-tiec2.aspx',N'Nến trang trí tiệc','17B7F6A6-48ED-4E4A-AA24-BFE4151B50B7',1),
('54BD8C34-127B-44E4-B4BD-177346E4759F','/trang-phuc-sinh-nhat-be2.aspx',N'Trang phục sinh nhật bé','17B7F6A6-48ED-4E4A-AA24-BFE4151B50B7',2)
go
insert into PAYMENT values
('81461F5F-D54D-4C49-83F5-72821161998A',N'Chuyển khoản'),
('9F2E175C-5B39-44F4-83AC-9A12A93EC419',N'Tiền mặt'),
('6332C289-36D3-41B6-9AB0-774AED061F63',N'Giao tại nhà')

go

insert into [Order] values
(newid(),'Duong Than Dan','email','123123','sg','note','81461F5F-D54D-4C49-83F5-72821161998A','','','2012-09-15 20:10:24.440',300000,0),
('E3B9330E-FEE6-40CA-852A-7341035BB4A9','Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
(newid(),'Dan','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
('9BCE0B92-3C97-430E-B815-7745F13CF42C','Dai 1','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0),
('FD72E2B9-0960-4A83-B2FE-7E6BA48EBFFB','Dai 2','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-09-15 20:10:24.440',300000,0)

go


insert into product values
('4F668A85-FC83-4A8E-AC48-A64CBC35C982','/product1.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 1','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',50,'2012-09-17 20:31:13.537',1,0),
('4F668A85-FC83-4A8E-AC48-A64CBC35C983','/product2.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 2','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',60,'2012-09-17 20:31:13.537',1,0),
('4F668A85-FC83-4A8E-AC48-A64CBC35C984','/product3.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 3','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',60,'2012-09-17 20:31:13.537',1,0),
('4F668A85-FC83-4A8E-AC48-A64CBC35C985','/product4.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 4','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',80,'2012-09-17 20:31:13.537',1,0),
('4F668A85-FC83-4A8E-AC48-A64CBC35C986','/product5.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 5','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',80,'2012-09-17 20:31:13.537',1,0),
('4F668A85-FC83-4A8E-AC48-A64CBC35C987','/product6.aspx', 'F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4755F','Product 6','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg', '',99,'2012-09-17 20:31:13.537',1,0)

insert into OrderDetail values
(newid(), '9BCE0B92-3C97-430E-B815-7745F13CF42C','4F668A85-FC83-4A8E-AC48-A64CBC35C982',2,1500),
(newid(), '9BCE0B92-3C97-430E-B815-7745F13CF42C','4F668A85-FC83-4A8E-AC48-A64CBC35C983',2,1200),
(newid(), '9BCE0B92-3C97-430E-B815-7745F13CF42C','4F668A85-FC83-4A8E-AC48-A64CBC35C984',2,1800),
(newid(), '9BCE0B92-3C97-430E-B815-7745F13CF42C','4F668A85-FC83-4A8E-AC48-A64CBC35C985',6,1500)

insert into [Service] values
('{F295CD98-E309-41AE-A6B4-4CFD73575028}', '/service9.aspx','F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4757F','2012-09-17 20:31:13.537','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg','title 1','content 1',0),
('{F295CD98-E309-41AE-A6B4-4CFD73575029}', '/service10.aspx','8A404ACC-0702-4940-BFAE-6F9D03901054','54BD8C34-127B-44E4-B4BD-177346E4757F','2012-09-17 20:31:13.537','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg','title 1','content 1',0),
('{F295CD98-E309-41AE-A6B4-4CFD73575030}', '/service11.aspx','8A404ACC-0702-4940-BFAE-6F9D03901054','54BD8C34-127B-44E4-B4BD-177346E4757F','2012-09-17 20:31:13.537','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg','title 1','content 1',0),
('{F295CD98-E309-41AE-A6B4-4CFD73575031}', '/service12.aspx','F31386F7-E717-46DF-ADB1-B32CD17441AE','54BD8C34-127B-44E4-B4BD-177346E4757F','2012-09-17 20:31:13.537','/data/images/d3ad3569-bba2-41b3-9a50-a9b4ead9cb4b.jpg','title 1','content 1',0)

insert into serviceorder values
(newid(),'F295CD98-E309-41AE-A6B4-4CFD73575030','Dan 2','email','123123','sg','note','81461F5F-D54D-4C49-83F5-72821161998A','','','2012-11-22 20:10:24.440',100,'2012-09-15 20:10:24.440',0),
(newid(),'F295CD98-E309-41AE-A6B4-4CFD73575031','Dan 1','email','123123','sg','note','6332C289-36D3-41B6-9AB0-774AED061F63','','','2012-11-22 20:10:24.440',100,'2012-09-15 20:10:24.440',0)


insert into CategoryService values
('{17B7F6A6-48ED-4E4A-AA24-BFE4151B50B7}','/trang-tri-tiec2.aspx', N'Trang trí tiệc', null,1),
('{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}','/to-chuc-sinh-nhat2.aspx', N'Dịch vụ tổ chức sinh nhật', null,2),
('54BD8C34-127B-44E4-B4BD-177346E4755F','/trang-tri-tiec-sinh-nhat2.aspx',N'Trang trí tiệc sinh nhật','{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}',1),
('54BD8C34-127B-44E4-B4BD-177346E4756F','/trang-tri-tiec-cuoi-ki-niem2.aspx',N'Trang trí tiệc cưới, kỉ niệm','{2C6F12D6-F5B4-42A7-9A7B-8FAB8149A5A5}',2)
go

alter table article add meta nvarchar(300)
alter table product add meta nvarchar(300)
alter table service add meta nvarchar(300)
